Analyze data like a pro, even if you’re a beginner. Practical SQL is an approachable and fast-paced guide to SQL (Structured Query Language), the standard programming language for defining, organizing, and exploring data in relational databases. Anthony DeBarros, a journalist and data analyst, focuses on using SQL to find the story within your data. The examples and code use th...(展开全部)

Practical SQL is an approachable and fast-paced guide to SQL (Structured Query Language), the standard programming language for defining, organizing, and exploring data in relational databases. The book focuses on using SQL to find the story your data tells, with the popular open-source database PostgreSQL and the pgAdmin interface as its primary tools. You’ll first cover the f...(展开全部)

Practical SQL is an approachable and fast-paced guide to SQL (Structured Query Language), the standard programming language for defining, organizing, and exploring data in relational databases. The book focuses on using SQL to find the story your data tells, with the popular open-source database PostgreSQL and the pgAdmin interface as its primary tools. You’ll first cover the f...(展开全部)

Query Solutions and Techniques for Database Developers

Query Solutions and Techniques for Database Developers

《SQL实战》是一本平易近人、节奏明快的SQL（Structured Query Language，结构化查询语言）指南。SQL是定义、组织和探索关系数据库中数据的标准程序设计语言。作为一名职业记者，安东尼·德巴罗斯专注于使用SQL寻找数据所讲述的故事。 本书首先会向你传授数据库和SQL语言的基础知识，然后通过分析诸如美国人口普查数据、纽约市出租车数据和全国农贸市场目录等现实世界的数据集来磨炼你的技能。通过本书每章展示的练习和示例，即使是编程新手也能够从中学到构建强大数据库和快速高效地访问信息所需的全部工具。 你将学会以下内容： - 使用你自有的数据创建数据库和表 - 聚合、排序和过滤数据以寻找模式 - 发现并纠正数据中的错误 - 为地理信息系统（GIS）编写查询 - 使用函数实施基本的数学运算以及高级的统计运算 - 创建高级查询和自动执行任务

現在的社會裡，資料就是力量；但通向成功殿堂的真正秘密，其實在於有能力掌控你的資料。《深入淺出 SQL》帶領讀者直探 SQL 語言的核心，從使用 INSERT 與 SELECT 的基礎查詢語法，一路講到使用子查詢、聯結、交易的硬底子資料庫操作。閱畢本書，讀者將不只瞭解有效果又有效率的資料庫建設方式，更能具有專家級的查詢、正規化與聯結操作水準。而且也將成為手邊資料的管理大師。 * 識別具有單元性的資料要素，並使用主鍵修改資料表。 * 建立資料庫與資料表的視圖。 * 觀察子查詢的源頭。 * 學習運算子特殊的地方。 * 發現複數資料表操作的益處。 * 使用 SQL 關鍵字管理交易。 為什麼我們如此與眾不同？ 各位的時間都很寶貴，不值得拿來與新觀念搏鬥。所以我們根據最新的認知科學與學習理論，設計出感官複合的學習體驗。《深入淺出 SQL》使用豐富精美、且符合大腦...(展开全部)

Get started with the fundamentals of Transact-SQL and learn how to write efficient and powerful database queries. With this hands-on guide, you'll gain a solid understanding of T-SQL and good programming practices through the right balance of conceptual and practical content. Learn the steps required to develop T-SQL code for retrieving and modifying data, with exercises to hel...(展开全部)

本书是热销书《SQL基础教程》的作者MICK为志在向中级进阶的数据库工程师编写的一本SQL技能提升指南。全书可分为两大部分。第一部分介绍了SQL语言不同寻常的使用技巧，带领读者重新认识CASE表达式、窗口函数、自连接、EXISTS谓词、HAVING子句、外连接、行间比较、集合运算、数列处理等SQL常用技术，发掘它们的新用法。这部分不仅穿插讲解了这些技巧背后的逻辑和相关知识，而且辅以丰富的示例程序，旨在帮助读者从面向过程的思维方式转换为面向集合的思维方式。第二部分介绍了关系数据库的发展史，并从集合论和逻辑学的角度讲述了SQL和关系模型的理论基础，旨在帮助读者加深对SQL语言和关系数据库的理解。此外，本书很多节的末尾设置有练习题，并在书末提供了解答，方便读者检验自己对书中知识点的掌握程度。

SQL injection (SQLi) is probably the most infamous attack that can be unleashed against applications on the internet. SQL Injection Strategies is an end-to-end guide for beginners looking to learn how to perform SQL injection and test the security of web applications, websites, or databases, using both manual and automated techniques. The book serves as both a theoretical and practical guide to take you through the important aspects of SQL injection, both from an attack and a defense perspective.You’ll start with a thorough introduction to SQL injection and its impact on websites and systems. Later, the book features steps to configure a virtual environment, so you can try SQL injection techniques safely on your own computer. These tests can be performed not only on web applications but also on web services and mobile applications that can be used for managing IoT environments. Tools such as sqlmap and others are then covered, helping you understand how to use them effectively to perform SQL injection attacks.By the end of this book, you will be well-versed with SQL injection, from both the attack and defense perspective.